package cn.hl.hm.dao;

import java.util.List;

import cn.hl.hm.entity.VehicleType;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import cn.hl.hm.entity.VehicleLength;

public interface VehicleLengthMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(VehicleLength record);

    int insertSelective(VehicleLength record);

    VehicleLength selectByPrimaryKey(Integer id);
    List<VehicleLength> selectByIds(@Param(value = "ids")List<Integer> ids);
    int updateByPrimaryKeySelective(VehicleLength record);

    int updateByPrimaryKey(VehicleLength record);
//    @Select("SELECT * FROM order_info WHERE user_id = #{user_id} order by add_time desc limit 200")
//    public List<OrderInfo> getOrderInfoByUserId(@Param("user_id") int user_id);
    @Select("SELECT * FROM vehicle_length  as vl where status = 0 order by vl.vehicle_length asc ")
    List<VehicleLength> selectVehicleLength();
    @Select("SELECT * FROM vehicle_length  as vl where status = 0 and vl.vehicle_length=#{length} ")
    List<VehicleLength> selectVLByLength(@Param("length")Double length);
}